EMT Practice Test

1. Question Content...

---

Question1: Which of the following is the overall installation process?

Question2: Are there any operators that can handle set operations?

Question3: GuassDB 200 implements logical cluster management to realize the division of a cluster into multiple small logical clusters in an existing MPPDB physical cluster to achieve isolation of computing and storage resources between logical clusters. Industry backup users cannot access data tables across clusters.

Question4: (Judgment) Window functions are used with the OVER statement. The OVER statement is used to group data and sort elements in the group; window functions are used to generate sequence numbers for the values in the group.

Question5: (Multiple choices). The following description about the selection of the distribution column is correct?

Question6: The following values can be expressed as Boolean "true"

Question7: Principles for selecting distribution columns in table design include

Question8: Which of the following are the basic functions of dual cluster disaster recovery?

Question9: The column storage engine is more suitable for OLAP big data statistical analysis scenarios.

Question10: Plan Hint will directly affect the generation of the execution plan, so errors in Hint will also affect the execution of the statement

Question11: To cascade delete database objects such as user-created tables, use the key word

Question12: The entire system network of GaussDB 200 is divided into planes?

Question13: Which of the following functions cannot be implemented by PostGIS?

Question14: (Judgment) In the MVCC mode, when each transaction retrieves data, it only sees a snapshot of the data some time ago, not the latest state of the data.

Question15: What algorithm does the CLOG log buffer use

Question16: GaussDB 200 tenant can configure the operation permissions of database objects

Question17: Which of the following types of logs records the final status of a transaction?

Question18: Which two steps are involved in a two-phase transaction submission

Question19: Please select an isolation type that is not supported by the logical cluster

Question20: How many implementation methods does GaussDB OLAP200 currently have?

Question21: Are there any Chinese-foreign joins?

Question22: For standby clusters, no services can be provided during recovery, and read-only services can be provided during non-recovery periods

Question23: The following table table operation constraints, the wrong one is

Question24: Are the following data distributed that do not belong to GaussDB200 OLAP?

Question25: GaussDB 200 only supports general-purpose servers based on x86 architecture.

Question26: (Multiple choices) Which databases does GaussDB 200 database system initially include?

Question27: Which of the following EXPLAIN command options actually executed the query?

Question28: Which of the following modules guarantees high availability through active-standby replication?

Question29: In the logical cluster mode, if a user needs to perform SQL operations across a logical cluster, the system can be configured to reserve resources for the purpose of resource control.

Question30: Append operator may have left and right child nodes?

Question31: Which of the following options is correct regarding active / standby switching?

Question32: The main function of the execution engine is to parse the SQL query entered by the user. Generate execution plan

Question33: After CN failure, the entire cluster will still be able to execute DDL statements?

Question34: What indexes does the GaussDB 200 database support

Question35: Is there any limit to using Nestloop operator to implement the link operation?

Question36: What is the high availability architecture of GaussDB 200?

Question37: Which of the following are typical deployment scenarios for logical clusters?

Question38: Benefits of Partitioning

Question39: Which of the TOAST data storage strategies allow compression?

Question40: The promotion and distribution of CSN are managed in ()

Question41: What are the types of redistribution

Question42: Which of the following are not permissions that the GaussDB200 role can control?

Question43: What security risks can database audits identify?

Question44: DBMD_JOB is mainly used to handle large object types

Question45: Which of the following components does the user service use to access the GaussDB 200 database?

Question46: FULL JOIN and CROSS JOIN results are equivalent

Question47: When the cluster status is Degraded: The cluster is available, but the data is not redundantly backed up. The DN master has one and only one exits abnormally. The GTM has only one host and the highest available mode. The CN has and only partially exits abnormally.

Question48: (Judgment) After CN failure, the entire cluster will still be able to execute DDL statements.

Question49: Which of the following types of indexes only supports equivalence queries?

Question50: Which of the following is not a tenant parameter configuration item

Question51: The library files compiled by C and PL / JAVA need to be deployed to the server to use

Question52: (Judgment) Any user can create a table space.

Question53: When using the Migration Tool, when migrating ordinary DDL statements (tables, views, indexes, sequences, etc.) without PL / SQL statements, you should use the BLogic mode (ie, set the migration-type parameter to Blogic)